using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.DataControl;
using System.Data.DataModel;

namespace WebAppWithDataEnum.Model
{
	public class TestMyClass:BaseModel
	{
		public TestMyClass() : base()
		{
			this.dbController.SelectAllCommand = this.selectAllString;
			this.dbController.SelectCommand = this.selectString;
			this.dbController.InsertCommand = this.insertString;
			this.dbController.UpdateCommand = this.updateString;
			this.dbController.DeleteCommand = this.deleteString;
		}
		private string selectAllString = "SELECT TestID,TestName FROM TestMyClass ";
		private string selectString = "SELECT TestID,TestName FROM TestMyClass  WHERE TestID = :TestID";
		private string updateString = "UPDATE TestMyClass SET  TestName=:TestName WHERE TestID = :TestID";
		private string insertString = "INSERT INTO TestMyClass( TestID, TestName) VALUES( :TestID, :TestName)";
		private string deleteString = "DELETE FROM TestMyClass WHERE TestID = :TestID";
		public System.Int32 TestID{ get; set; }

		public System.Int32 TestName{ get; set; }


	}
}
